Week 2

Milestones

• Creating sample database - Sync_telemetry (10k), Program_enrolment (10k), Program encounter (100k), Encounter (100k), Users (10), Individuals (10k).
• Uploading data to avni database using bulk upload feature and also directly to pgAdmin database on local.
• Analysing data on Canned Analytics page.
• Write ETL to move sync_telemetry and users.

Screenshots / Videos

Canned Analytics showing the data uploaded:

• HR tab

  
  

• Activities tab

Contributions

• https://github.com/AvinashRamachandruni/avni-etl/issues/1
• https://github.com/AvinashRamachandruni/avni-etl/issues/2

Learnings

• Understood about the data being showed in canned analytics page.
• Generating data using Python and uploading it using bulk upload.
• Understanding complete workflow of ETL code.